<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateYbzCreateAndEditTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('nw_ybz_create_and_edit', function (Blueprint $table) {
          $table->id();
            
          // 系统名称
          $table->string('system_name')->comment('系统名称');
          
          // 名称
          $table->string('resource_name')->comment('名称');
          
          // 类型
          $table->string('type')->comment('类型');
          
          // 内网/外网
          $table->string('network_type')->comment('内网/外网');
          
          // 资源类型
          $table->string('resource_type')->comment('资源类型');
          
          // 变更vcpu
          $table->integer('modified_vcpu')->comment('变更vcpu');
          
          // 变更内存GB
          $table->integer('modified_memory_gb')->comment('变更内存GB');
          
          // 变更存储GB
          $table->integer('modified_storage_gb')->comment('变更存储GB');
          
          // 日期
          $table->string('date')->comment('日期');
          $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('nw_ybz_create_and_edit');
    }
}
